﻿<?xml version="1.0" encoding="utf-8" ?> 
<sqlMap namespace="Complex" 
xmlns="http://ibatis.apache.org/mapping" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	
	<statements>
	
		<statement id="ComplexMap"
			resultClass="${nullableInt}" >
			select Account_ID from Accounts where Account_ID = #obj.Map.Id#
		</statement>
		
		<insert id="InsertComplexAccountViaInlineDefaultNull"
			parameterClass="Hashtable" >
			insert into Accounts 
				(Account_ID, Account_FirstName, Account_LastName, Account_Email) 
			values 
				(#obj.Map.acct.Id#, #obj.Map.acct.FirstName#, #obj.Map.acct.LastName#, #obj.Map.acct.EmailAddress:VarChar:no_email@provided.com#
			)
		</insert>
				
	</statements>

	
</sqlMap>
